﻿CREATE VIEW dbo.TestQueryDefs
AS
SELECT     u.Login, u.Password, u.System, s.ConnectionString, q.Sql
FROM         dbo.UsersDef AS u RIGHT OUTER JOIN
                      dbo.SystemDef AS s ON s.SystemName = u.System RIGHT OUTER JOIN
                      dbo.TestQueries AS q ON q.System = u.System

GO

